Removing the configuration for the SAS WebApplication Server does not remove the data source definition. As a result, multiple data source definitions are left in the server.xml file.

When you reconfigure an environment, the SAS^® Deployment Wizard picks up the first data source definition in file rather than the newly created data source definition. When this problem happens, there might not be any symptoms or indications because the wizard picks up a data source definition (even if it is not the correct one).

As a workaround for this problem, you need to modify the server.xml file that resides in the SAS-configuration-directory\Levn\Web\WebAppServer\SASServerN_M\conf\ directory.

In the server.xml file:

1. Search for the uniqueResourceName= parameter, as shown in the example below:
   
   uniqueResourceName="sas/jdbc/MonitorDataSource" url="jdbc:oracle:thin:@localdb.na.sas.com:1523:localdb"
2. Change the JDBC URL (highlighted) to the correct URL value.

Operating System and Release Information